{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>职位名称</th>\n",
       "      <th>每月薪水</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>最低学历</th>\n",
       "      <th>发布日期</th>\n",
       "      <th>所需经验</th>\n",
       "      <th>职位-url</th>\n",
       "      <th>公司-url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>招聘临床项目经理</td>\n",
       "      <td>20-30k·12薪</td>\n",
       "      <td>汉康医药</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927252479.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7863405/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>招聘融创学院东南分院院长</td>\n",
       "      <td>40-55k·17薪</td>\n",
       "      <td>融创中国杭州公司</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>8年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927252423.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8160923/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>招聘运维工程师</td>\n",
       "      <td>面议</td>\n",
       "      <td>旗天科技集团股份有限公司</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927252137.shtml</td>\n",
       "      <td>https://www.liepin.com/company/6626712/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>招聘产品总监</td>\n",
       "      <td>面议</td>\n",
       "      <td>辽宁省鑫源温控技术有限公司</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>10年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927252129.shtml</td>\n",
       "      <td>https://www.liepin.com/company/12138163/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>招聘中建六局土木公司（企业策划与管理部内控及风险管理岗）</td>\n",
       "      <td>6-8k·14薪</td>\n",
       "      <td>中建六局土木工程有限公司</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927251795.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7999925/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>招聘风控经理</td>\n",
       "      <td>15-25k·12薪</td>\n",
       "      <td>翼龙贷</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>6年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927251115.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7856638/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>招聘高级财经编辑</td>\n",
       "      <td>20-30k·14薪</td>\n",
       "      <td>你我贷</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>4年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927250601.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8639190/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>招聘工程管理中心总监</td>\n",
       "      <td>25-30k·12薪</td>\n",
       "      <td>深圳安星建设集团有限公司</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>10年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927250195.shtml</td>\n",
       "      <td>https://www.liepin.com/company/10107425/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>招聘产品工程师</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>武汉中岩科技股份有限公司</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>1年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927249763.shtml</td>\n",
       "      <td>https://www.liepin.com/company/10001249/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>招聘招聘主管</td>\n",
       "      <td>9-16k·15薪</td>\n",
       "      <td>碧桂园营销中心-上海区域</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>1年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927248447.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9107550/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>招聘城市总  （地点可以根据公司调剂区域做好）</td>\n",
       "      <td>30-50k·12薪</td>\n",
       "      <td>济南可恩口腔医院有限公司</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>10年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927248195.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8267148/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>招聘种植技术总监G00167</td>\n",
       "      <td>8-15k·12薪</td>\n",
       "      <td>巨星农牧股份</td>\n",
       "      <td>博士</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>1年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927248069.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8912844/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>招聘业务副总经理</td>\n",
       "      <td>25-30k·12薪</td>\n",
       "      <td>福建海峡高速客滚航运有限公司</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>6年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927247923.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7936319/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>招聘PMC计划主管</td>\n",
       "      <td>5-8k·12薪</td>\n",
       "      <td>常州嘉顿照明科技有限公司</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927247825.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9876701/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>招聘投资总监</td>\n",
       "      <td>面议</td>\n",
       "      <td>全民通</td>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927247699.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8602237/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>招聘分公司总部党群工作部部长</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>中建二局第二建筑工程有限公司</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>4年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927247185.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8400303/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>招聘客服主管</td>\n",
       "      <td>6-9k·12薪</td>\n",
       "      <td>湖南狐轩服饰有限公司</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927230155.shtml</td>\n",
       "      <td>https://www.liepin.com/company/10202635/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>招聘市场开发岗（信用业务部）</td>\n",
       "      <td>面议</td>\n",
       "      <td>华鑫证券</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>https://www.liepin.com/job/1927223143.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7859668/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>招聘固定收益研究员-ABS方向（研究发展部）</td>\n",
       "      <td>面议</td>\n",
       "      <td>华鑫证券</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>https://www.liepin.com/job/1927223055.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7859668/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>招聘化工行业研究员（研究发展部）</td>\n",
       "      <td>面议</td>\n",
       "      <td>华鑫证券</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>https://www.liepin.com/job/1927223015.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7859668/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>招聘非银金融行业研究员（研究发展部）</td>\n",
       "      <td>面议</td>\n",
       "      <td>华鑫证券</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>https://www.liepin.com/job/1927222875.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7859668/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>招聘交运设备行业研究员（研究发展部）</td>\n",
       "      <td>面议</td>\n",
       "      <td>华鑫证券</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>https://www.liepin.com/job/1927222825.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7859668/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>招聘TMT-电子行业研究员（研究发展部）</td>\n",
       "      <td>面议</td>\n",
       "      <td>华鑫证券</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>https://www.liepin.com/job/1927222739.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7859668/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>招聘TMT-通信行业研究员（研究发展部）</td>\n",
       "      <td>面议</td>\n",
       "      <td>华鑫证券</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>https://www.liepin.com/job/1927222693.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7859668/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>招聘法务经理</td>\n",
       "      <td>面议</td>\n",
       "      <td>福建省领秀文旅集团有限公司</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927221947.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8622201/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>招聘投拓经理</td>\n",
       "      <td>面议</td>\n",
       "      <td>福建省领秀文旅集团有限公司</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>https://www.liepin.com/job/1927221777.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8622201/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>招聘算法总监/CTO</td>\n",
       "      <td>70-100k·14薪</td>\n",
       "      <td>深圳爱拼信息科技有限公司</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927221187.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9107176/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>招聘战略总监/高级副总裁</td>\n",
       "      <td>45-60k·14薪</td>\n",
       "      <td>深圳爱拼信息科技有限公司</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927220839.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9107176/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>招聘企划经理</td>\n",
       "      <td>7-12k·12薪</td>\n",
       "      <td>酒客来网络科技有限公司</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927219419.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8591626/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>招聘天猫运营</td>\n",
       "      <td>15-20k·12薪</td>\n",
       "      <td>音王电声股份有限公司</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927218697.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8667439/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>招聘Controller</td>\n",
       "      <td>面议</td>\n",
       "      <td>卡索多丽娅贸易(上海)有限公司</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>2年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927217031.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9094662/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>招聘高级产品企划</td>\n",
       "      <td>15-25k·12薪</td>\n",
       "      <td>华帝股份</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927216631.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7925053/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>招聘施工经理(医疗建筑)</td>\n",
       "      <td>面议</td>\n",
       "      <td>上海市机电设计研究院有限公司</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927216395.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8028416/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>招聘设计经理(医疗建筑)</td>\n",
       "      <td>面议</td>\n",
       "      <td>上海市机电设计研究院有限公司</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927216325.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8028416/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>招聘项目经理（医疗建筑）</td>\n",
       "      <td>面议</td>\n",
       "      <td>上海市机电设计研究院有限公司</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927216209.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8028416/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>招聘渠道推广（陕南陕北）</td>\n",
       "      <td>5-10k·12薪</td>\n",
       "      <td>陕西长宇酒业有限公司</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927215425.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9624258/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>招聘市场部助理</td>\n",
       "      <td>4-6k·13薪</td>\n",
       "      <td>瑞德电子</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>https://www.liepin.com/job/1927212523.shtml</td>\n",
       "      <td>https://www.liepin.com/company/2871176/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>招聘招投标主管</td>\n",
       "      <td>4-7k·12薪</td>\n",
       "      <td>云南腾俊国际物流有限公司</td>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>1年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927211979.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1179133/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>招聘采购工程师</td>\n",
       "      <td>6-7k·13薪</td>\n",
       "      <td>深圳影迈科技有限公司</td>\n",
       "      <td>学历不限</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>1年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927211369.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9536304/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>招聘薪酬绩效主管</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>上海意鹰信息技术有限公司</td>\n",
       "      <td>大专及以上</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>https://www.liepin.com/job/1927208531.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1903423/</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            职位名称         每月薪水             公司名称   最低学历  \\\n",
       "0                       招聘临床项目经理   20-30k·12薪             汉康医药  本科及以上   \n",
       "1                   招聘融创学院东南分院院长   40-55k·17薪         融创中国杭州公司   统招本科   \n",
       "2                        招聘运维工程师           面议     旗天科技集团股份有限公司  本科及以上   \n",
       "3                         招聘产品总监           面议    辽宁省鑫源温控技术有限公司  大专及以上   \n",
       "4   招聘中建六局土木公司（企业策划与管理部内控及风险管理岗）     6-8k·14薪     中建六局土木工程有限公司  本科及以上   \n",
       "5                         招聘风控经理   15-25k·12薪              翼龙贷   统招本科   \n",
       "6                       招聘高级财经编辑   20-30k·14薪              你我贷  本科及以上   \n",
       "7                     招聘工程管理中心总监   25-30k·12薪     深圳安星建设集团有限公司  本科及以上   \n",
       "8                        招聘产品工程师     6-8k·12薪     武汉中岩科技股份有限公司   统招本科   \n",
       "9                         招聘招聘主管    9-16k·15薪     碧桂园营销中心-上海区域  大专及以上   \n",
       "10       招聘城市总  （地点可以根据公司调剂区域做好）   30-50k·12薪     济南可恩口腔医院有限公司  本科及以上   \n",
       "11                招聘种植技术总监G00167    8-15k·12薪           巨星农牧股份     博士   \n",
       "12                      招聘业务副总经理   25-30k·12薪   福建海峡高速客滚航运有限公司  大专及以上   \n",
       "13                     招聘PMC计划主管     5-8k·12薪     常州嘉顿照明科技有限公司   学历不限   \n",
       "14                        招聘投资总监           面议              全民通  硕士及以上   \n",
       "15                招聘分公司总部党群工作部部长   10-15k·12薪   中建二局第二建筑工程有限公司  本科及以上   \n",
       "16                        招聘客服主管     6-9k·12薪       湖南狐轩服饰有限公司  大专及以上   \n",
       "17                招聘市场开发岗（信用业务部）           面议             华鑫证券   学历不限   \n",
       "18        招聘固定收益研究员-ABS方向（研究发展部）           面议             华鑫证券   学历不限   \n",
       "19              招聘化工行业研究员（研究发展部）           面议             华鑫证券   学历不限   \n",
       "20            招聘非银金融行业研究员（研究发展部）           面议             华鑫证券   学历不限   \n",
       "21            招聘交运设备行业研究员（研究发展部）           面议             华鑫证券   学历不限   \n",
       "22          招聘TMT-电子行业研究员（研究发展部）           面议             华鑫证券   学历不限   \n",
       "23          招聘TMT-通信行业研究员（研究发展部）           面议             华鑫证券  本科及以上   \n",
       "24                        招聘法务经理           面议    福建省领秀文旅集团有限公司  本科及以上   \n",
       "25                        招聘投拓经理           面议    福建省领秀文旅集团有限公司  本科及以上   \n",
       "26                    招聘算法总监/CTO  70-100k·14薪     深圳爱拼信息科技有限公司  本科及以上   \n",
       "27                  招聘战略总监/高级副总裁   45-60k·14薪     深圳爱拼信息科技有限公司  本科及以上   \n",
       "28                        招聘企划经理    7-12k·12薪      酒客来网络科技有限公司  大专及以上   \n",
       "29                        招聘天猫运营   15-20k·12薪       音王电声股份有限公司  大专及以上   \n",
       "30                  招聘Controller           面议  卡索多丽娅贸易(上海)有限公司  本科及以上   \n",
       "31                      招聘高级产品企划   15-25k·12薪             华帝股份   统招本科   \n",
       "32                  招聘施工经理(医疗建筑)           面议   上海市机电设计研究院有限公司  大专及以上   \n",
       "33                  招聘设计经理(医疗建筑)           面议   上海市机电设计研究院有限公司  本科及以上   \n",
       "34                  招聘项目经理（医疗建筑）           面议   上海市机电设计研究院有限公司  本科及以上   \n",
       "35                  招聘渠道推广（陕南陕北）    5-10k·12薪       陕西长宇酒业有限公司  大专及以上   \n",
       "36                       招聘市场部助理     4-6k·13薪             瑞德电子  大专及以上   \n",
       "37                       招聘招投标主管     4-7k·12薪     云南腾俊国际物流有限公司  本科及以上   \n",
       "38                       招聘采购工程师     6-7k·13薪       深圳影迈科技有限公司   学历不限   \n",
       "39                      招聘薪酬绩效主管   10-15k·12薪     上海意鹰信息技术有限公司  大专及以上   \n",
       "\n",
       "           发布日期   所需经验                                       职位-url  \\\n",
       "0   2020年04月07日   5年以上  https://www.liepin.com/job/1927252479.shtml   \n",
       "1   2020年04月07日   8年以上  https://www.liepin.com/job/1927252423.shtml   \n",
       "2   2020年04月07日   3年以上  https://www.liepin.com/job/1927252137.shtml   \n",
       "3   2020年04月07日  10年以上  https://www.liepin.com/job/1927252129.shtml   \n",
       "4   2020年04月07日   3年以上  https://www.liepin.com/job/1927251795.shtml   \n",
       "5   2020年04月07日   6年以上  https://www.liepin.com/job/1927251115.shtml   \n",
       "6   2020年04月07日   4年以上  https://www.liepin.com/job/1927250601.shtml   \n",
       "7   2020年04月07日  10年以上  https://www.liepin.com/job/1927250195.shtml   \n",
       "8   2020年04月07日   1年以上  https://www.liepin.com/job/1927249763.shtml   \n",
       "9   2020年04月07日   1年以上  https://www.liepin.com/job/1927248447.shtml   \n",
       "10  2020年04月07日  10年以上  https://www.liepin.com/job/1927248195.shtml   \n",
       "11  2020年04月07日   1年以上  https://www.liepin.com/job/1927248069.shtml   \n",
       "12  2020年04月07日   6年以上  https://www.liepin.com/job/1927247923.shtml   \n",
       "13  2020年04月07日   3年以上  https://www.liepin.com/job/1927247825.shtml   \n",
       "14  2020年04月07日   5年以上  https://www.liepin.com/job/1927247699.shtml   \n",
       "15  2020年04月07日   4年以上  https://www.liepin.com/job/1927247185.shtml   \n",
       "16  2020年04月07日   5年以上  https://www.liepin.com/job/1927230155.shtml   \n",
       "17  2020年04月07日   经验不限  https://www.liepin.com/job/1927223143.shtml   \n",
       "18  2020年04月07日   经验不限  https://www.liepin.com/job/1927223055.shtml   \n",
       "19  2020年04月07日   经验不限  https://www.liepin.com/job/1927223015.shtml   \n",
       "20  2020年04月07日   经验不限  https://www.liepin.com/job/1927222875.shtml   \n",
       "21  2020年04月07日   经验不限  https://www.liepin.com/job/1927222825.shtml   \n",
       "22  2020年04月07日   经验不限  https://www.liepin.com/job/1927222739.shtml   \n",
       "23  2020年04月07日   经验不限  https://www.liepin.com/job/1927222693.shtml   \n",
       "24  2020年04月07日   5年以上  https://www.liepin.com/job/1927221947.shtml   \n",
       "25  2020年04月07日   经验不限  https://www.liepin.com/job/1927221777.shtml   \n",
       "26  2020年04月07日   5年以上  https://www.liepin.com/job/1927221187.shtml   \n",
       "27  2020年04月07日   5年以上  https://www.liepin.com/job/1927220839.shtml   \n",
       "28  2020年04月07日   5年以上  https://www.liepin.com/job/1927219419.shtml   \n",
       "29  2020年04月07日   5年以上  https://www.liepin.com/job/1927218697.shtml   \n",
       "30  2020年04月07日   2年以上  https://www.liepin.com/job/1927217031.shtml   \n",
       "31  2020年04月07日   5年以上  https://www.liepin.com/job/1927216631.shtml   \n",
       "32  2020年04月07日   5年以上  https://www.liepin.com/job/1927216395.shtml   \n",
       "33  2020年04月07日   5年以上  https://www.liepin.com/job/1927216325.shtml   \n",
       "34  2020年04月07日   5年以上  https://www.liepin.com/job/1927216209.shtml   \n",
       "35  2020年04月07日   3年以上  https://www.liepin.com/job/1927215425.shtml   \n",
       "36  2020年04月07日   经验不限  https://www.liepin.com/job/1927212523.shtml   \n",
       "37  2020年04月07日   1年以上  https://www.liepin.com/job/1927211979.shtml   \n",
       "38  2020年04月07日   1年以上  https://www.liepin.com/job/1927211369.shtml   \n",
       "39  2020年04月07日   3年以上  https://www.liepin.com/job/1927208531.shtml   \n",
       "\n",
       "                                      公司-url  \n",
       "0    https://www.liepin.com/company/7863405/  \n",
       "1    https://www.liepin.com/company/8160923/  \n",
       "2    https://www.liepin.com/company/6626712/  \n",
       "3   https://www.liepin.com/company/12138163/  \n",
       "4    https://www.liepin.com/company/7999925/  \n",
       "5    https://www.liepin.com/company/7856638/  \n",
       "6    https://www.liepin.com/company/8639190/  \n",
       "7   https://www.liepin.com/company/10107425/  \n",
       "8   https://www.liepin.com/company/10001249/  \n",
       "9    https://www.liepin.com/company/9107550/  \n",
       "10   https://www.liepin.com/company/8267148/  \n",
       "11   https://www.liepin.com/company/8912844/  \n",
       "12   https://www.liepin.com/company/7936319/  \n",
       "13   https://www.liepin.com/company/9876701/  \n",
       "14   https://www.liepin.com/company/8602237/  \n",
       "15   https://www.liepin.com/company/8400303/  \n",
       "16  https://www.liepin.com/company/10202635/  \n",
       "17   https://www.liepin.com/company/7859668/  \n",
       "18   https://www.liepin.com/company/7859668/  \n",
       "19   https://www.liepin.com/company/7859668/  \n",
       "20   https://www.liepin.com/company/7859668/  \n",
       "21   https://www.liepin.com/company/7859668/  \n",
       "22   https://www.liepin.com/company/7859668/  \n",
       "23   https://www.liepin.com/company/7859668/  \n",
       "24   https://www.liepin.com/company/8622201/  \n",
       "25   https://www.liepin.com/company/8622201/  \n",
       "26   https://www.liepin.com/company/9107176/  \n",
       "27   https://www.liepin.com/company/9107176/  \n",
       "28   https://www.liepin.com/company/8591626/  \n",
       "29   https://www.liepin.com/company/8667439/  \n",
       "30   https://www.liepin.com/company/9094662/  \n",
       "31   https://www.liepin.com/company/7925053/  \n",
       "32   https://www.liepin.com/company/8028416/  \n",
       "33   https://www.liepin.com/company/8028416/  \n",
       "34   https://www.liepin.com/company/8028416/  \n",
       "35   https://www.liepin.com/company/9624258/  \n",
       "36   https://www.liepin.com/company/2871176/  \n",
       "37   https://www.liepin.com/company/1179133/  \n",
       "38   https://www.liepin.com/company/9536304/  \n",
       "39   https://www.liepin.com/company/1903423/  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from requests_html import HTMLSession\n",
    "import pandas as pd\n",
    "\n",
    "url = \"https://www.liepin.com/zhaopin/?keyword=design\"\n",
    "session = HTMLSession()\n",
    "r = session.get( url )\n",
    "\n",
    "data = {\n",
    "        \"职位名称\":r.html.xpath('//div[@class=\"job-info\"]/h3/@title'),           \n",
    "        \"每月薪水\":r.html.xpath('//span[@class=\"text-warning\"]/text()'),\n",
    "         \"公司名称\":r.html.xpath('//p[@class=\"company-name\"]/a/text()'),\n",
    "         \"最低学历\":r.html.xpath('//span[@class=\"edu\"]/text()'),\n",
    "         \"发布日期\":r.html.xpath('//p[@class=\"time-info clearfix\"]/time/@title'),\n",
    "         \"所需经验\":r.html.xpath('//p[@class=\"condition clearfix\"]/span[3]/text()'),\n",
    "        \"职位-url\":r.html.xpath('//div[@class=\"job-info\"]/h3/a/@href'),  \n",
    "         \"公司-url\":r.html.xpath('//p[@class=\"company-name\"]/a/@href'),\n",
    "           \n",
    "}\n",
    "df = pd.DataFrame(data)\n",
    "df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_excel(\"Web_week03_liepin.xlsx\", sheet_name=\"搜查结果\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['https://www.liepin.com/company/7863405/',\n",
       " 'https://www.liepin.com/company/8160923/',\n",
       " 'https://www.liepin.com/company/6626712/',\n",
       " 'https://www.liepin.com/company/12138163/',\n",
       " 'https://www.liepin.com/company/7999925/',\n",
       " 'https://www.liepin.com/company/7856638/',\n",
       " 'https://www.liepin.com/company/8639190/',\n",
       " 'https://www.liepin.com/company/10107425/',\n",
       " 'https://www.liepin.com/company/10001249/',\n",
       " 'https://www.liepin.com/company/9107550/',\n",
       " 'https://www.liepin.com/company/8267148/',\n",
       " 'https://www.liepin.com/company/8912844/',\n",
       " 'https://www.liepin.com/company/7936319/',\n",
       " 'https://www.liepin.com/company/9876701/',\n",
       " 'https://www.liepin.com/company/8602237/',\n",
       " 'https://www.liepin.com/company/8400303/',\n",
       " 'https://www.liepin.com/company/10202635/',\n",
       " 'https://www.liepin.com/company/7859668/',\n",
       " 'https://www.liepin.com/company/7859668/',\n",
       " 'https://www.liepin.com/company/7859668/',\n",
       " 'https://www.liepin.com/company/7859668/',\n",
       " 'https://www.liepin.com/company/7859668/',\n",
       " 'https://www.liepin.com/company/7859668/',\n",
       " 'https://www.liepin.com/company/7859668/',\n",
       " 'https://www.liepin.com/company/8622201/',\n",
       " 'https://www.liepin.com/company/8622201/',\n",
       " 'https://www.liepin.com/company/9107176/',\n",
       " 'https://www.liepin.com/company/9107176/',\n",
       " 'https://www.liepin.com/company/8591626/',\n",
       " 'https://www.liepin.com/company/8667439/',\n",
       " 'https://www.liepin.com/company/9094662/',\n",
       " 'https://www.liepin.com/company/7925053/',\n",
       " 'https://www.liepin.com/company/8028416/',\n",
       " 'https://www.liepin.com/company/8028416/',\n",
       " 'https://www.liepin.com/company/8028416/',\n",
       " 'https://www.liepin.com/company/9624258/',\n",
       " 'https://www.liepin.com/company/2871176/',\n",
       " 'https://www.liepin.com/company/1179133/',\n",
       " 'https://www.liepin.com/company/9536304/',\n",
       " 'https://www.liepin.com/company/1903423/']"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "links=r.html.xpath('//p[@class=\"company-name\"]/a/@href')\n",
    "links"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/7863405/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/8160923/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/6626712/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/12138163/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/7999925/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/7856638/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/8639190/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/10107425/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/10001249/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/9107550/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/8267148/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/8912844/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/7936319/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/9876701/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/8602237/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/8400303/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/10202635/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/7859668/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/7859668/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/7859668/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/7859668/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/7859668/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/7859668/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/7859668/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/8622201/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/8622201/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/9107176/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/9107176/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/8591626/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/8667439/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/9094662/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/7925053/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/8028416/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/8028416/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/8028416/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/9624258/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/2871176/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/1179133/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/9536304/', params='', query='', fragment='')\n",
      "ParseResult(scheme='https', netloc='www.liepin.com', path='/company/1903423/', params='', query='', fragment='')\n"
     ]
    }
   ],
   "source": [
    "# 使用urllib3 解析 url\n",
    "from urllib.parse import urlparse, parse_qs\n",
    "for x in links:\n",
    "    urlparse(x)\n",
    "    print(urlparse(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[<Element 'div' class=('search-conditions',) data-selector='search-conditions'>]\n",
      "<Element 'div' class=('search-conditions',) data-selector='search-conditions'>\n",
      "[<Element 'dt' class=('search-title',)>, <Element 'dt' class=('search-title',)>, <Element 'dt' class=('search-title',)>, <Element 'dt' class=('search-title',)>, <Element 'dt' class=('search-title',)>]\n",
      "公司：\n",
      "行业：\n",
      "城市：\n",
      "薪资：\n",
      "更多：\n",
      "<Element 'dd' class=('comp-list',)>\n",
      "<Element 'dd' class=('short-dd', 'select-industry') data-param='industries'>\n",
      "<Element 'dd' data-param='city'>\n",
      "<Element 'dd' data-param='salary'>\n",
      "<Element 'dd' class=('dropdown', 'dropdown-time')>\n",
      "<Element 'dd' class=('dropdown', 'dropdown-jobkind')>\n",
      "<Element 'dd' class=('dropdown', 'dropdown-compscale')>\n",
      "<Element 'dd' class=('dropdown', 'dropdown-compkind')>\n"
     ]
    }
   ],
   "source": [
    "# A-2 扩张为公司\n",
    "main = r.html.xpath('//div[@data-selector=\"search-conditions\"]') #最外包的元素\n",
    "print (main)\n",
    "print (main[0])  #第一个\n",
    "print (main[0].xpath('//dt[@class=\"search-title\"]'))   # 获得第一个元素的xpath\n",
    "list_search_title = r.html.xpath('//dt[@class=\"search-title\"]')\n",
    "for x in list_search_title:\n",
    "    print (x.text)\n",
    "\n",
    "list_search_dd = main[0].xpath('//dt[@class=\"search-title\"]/following-sibling::dd')\n",
    "for x in list_search_dd:\n",
    "    print (x) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[<Element 'a' class=() href='/zhaopin/?init=-1&headckid=49f609c13719e8a0&flushckid=1&fromSearchBtn=2&keyword=design&compTag=155&ckid=49f609c13719e8a0&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=de352ed57e16600a3d85130dcb8090a4&d_curPage=0&d_pageSize=40&d_headId=de352ed57e16600a3d85130dcb8090a4'>,\n",
       " <Element 'a' class=() href='/zhaopin/?init=-1&headckid=49f609c13719e8a0&flushckid=1&fromSearchBtn=2&keyword=design&compTag=182&ckid=49f609c13719e8a0&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=de352ed57e16600a3d85130dcb8090a4&d_curPage=0&d_pageSize=40&d_headId=de352ed57e16600a3d85130dcb8090a4'>,\n",
       " <Element 'a' class=() href='/zhaopin/?init=-1&headckid=49f609c13719e8a0&flushckid=1&fromSearchBtn=2&keyword=design&compTag=186&ckid=49f609c13719e8a0&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=de352ed57e16600a3d85130dcb8090a4&d_curPage=0&d_pageSize=40&d_headId=de352ed57e16600a3d85130dcb8090a4'>,\n",
       " <Element 'a' class=() href='/zhaopin/?init=-1&headckid=49f609c13719e8a0&flushckid=1&fromSearchBtn=2&keyword=design&compTag=189&ckid=49f609c13719e8a0&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=de352ed57e16600a3d85130dcb8090a4&d_curPage=0&d_pageSize=40&d_headId=de352ed57e16600a3d85130dcb8090a4'>,\n",
       " <Element 'a' class=() href='/zhaopin/?init=-1&headckid=49f609c13719e8a0&flushckid=1&fromSearchBtn=2&keyword=design&compTag=130&ckid=49f609c13719e8a0&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=de352ed57e16600a3d85130dcb8090a4&d_curPage=0&d_pageSize=40&d_headId=de352ed57e16600a3d85130dcb8090a4'>,\n",
       " <Element 'a' class=() href='/zhaopin/?init=-1&headckid=49f609c13719e8a0&flushckid=1&fromSearchBtn=2&keyword=design&compTag=156&ckid=49f609c13719e8a0&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=de352ed57e16600a3d85130dcb8090a4&d_curPage=0&d_pageSize=40&d_headId=de352ed57e16600a3d85130dcb8090a4'>]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "company_link = r.html.xpath('//div[@data-selector=\"search-conditions\"]')[0] \\\n",
    "                    .xpath('//dt[@class=\"search-title\"]/following-sibling::dd')[0] \\\n",
    "                    .xpath('//div[contains(@class,\"hot-comp-tags\")]/a/@href')\n",
    "company_link\n",
    "company_link = r.html.xpath('//div[@data-selector=\"search-conditions\"]')[0] \\\n",
    "                    .xpath('//dt[@class=\"search-title\"]/following-sibling::dd')[0] \\\n",
    "                    .xpath('//div[contains(@class,\"hot-comp-tags\")]/a')\n",
    "company_link"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'中国500强': '/zhaopin/?init=-1&headckid=49f609c13719e8a0&flushckid=1&fromSearchBtn=2&keyword=design&compTag=155&ckid=49f609c13719e8a0&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=de352ed57e16600a3d85130dcb8090a4&d_curPage=0&d_pageSize=40&d_headId=de352ed57e16600a3d85130dcb8090a4',\n",
       " '2018互联网300强': '/zhaopin/?init=-1&headckid=49f609c13719e8a0&flushckid=1&fromSearchBtn=2&keyword=design&compTag=182&ckid=49f609c13719e8a0&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=de352ed57e16600a3d85130dcb8090a4&d_curPage=0&d_pageSize=40&d_headId=de352ed57e16600a3d85130dcb8090a4',\n",
       " '制造业500强': '/zhaopin/?init=-1&headckid=49f609c13719e8a0&flushckid=1&fromSearchBtn=2&keyword=design&compTag=186&ckid=49f609c13719e8a0&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=de352ed57e16600a3d85130dcb8090a4&d_curPage=0&d_pageSize=40&d_headId=de352ed57e16600a3d85130dcb8090a4',\n",
       " 'AI创新成长50强 ': '/zhaopin/?init=-1&headckid=49f609c13719e8a0&flushckid=1&fromSearchBtn=2&keyword=design&compTag=189&ckid=49f609c13719e8a0&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=de352ed57e16600a3d85130dcb8090a4&d_curPage=0&d_pageSize=40&d_headId=de352ed57e16600a3d85130dcb8090a4',\n",
       " '独角兽': '/zhaopin/?init=-1&headckid=49f609c13719e8a0&flushckid=1&fromSearchBtn=2&keyword=design&compTag=130&ckid=49f609c13719e8a0&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=de352ed57e16600a3d85130dcb8090a4&d_curPage=0&d_pageSize=40&d_headId=de352ed57e16600a3d85130dcb8090a4',\n",
       " '上市公司': '/zhaopin/?init=-1&headckid=49f609c13719e8a0&flushckid=1&fromSearchBtn=2&keyword=design&compTag=156&ckid=49f609c13719e8a0&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=de352ed57e16600a3d85130dcb8090a4&d_curPage=0&d_pageSize=40&d_headId=de352ed57e16600a3d85130dcb8090a4'}"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#[ x.xpath(\"a/@href\")[0] for x in company_link]\n",
    "#[ x.xpath(\"a/text()\")[0] for x in company_link]\n",
    "company_link = { x.xpath(\"a/text()\")[0]:x.xpath(\"a/@href\")[0] for x in company_link}\n",
    "company_link\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 6 entries, 0 to 5\n",
      "Data columns (total 6 columns):\n",
      "scheme      6 non-null object\n",
      "netloc      6 non-null object\n",
      "path        6 non-null object\n",
      "params      6 non-null object\n",
      "query       6 non-null object\n",
      "fragment    6 non-null object\n",
      "dtypes: object(6)\n",
      "memory usage: 368.0+ bytes\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "df = pd.DataFrame([ urlparse(x) for x in company_link.values()])  # urlparse 是拿来解析url的\n",
    "df.info()   #info是查找相关信息"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "scheme      1\n",
      "netloc      1\n",
      "path        1\n",
      "params      1\n",
      "query       6\n",
      "fragment    1\n",
      "dtype: int64\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>scheme</th>\n",
       "      <th>netloc</th>\n",
       "      <th>path</th>\n",
       "      <th>params</th>\n",
       "      <th>query</th>\n",
       "      <th>fragment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>/zhaopin/</td>\n",
       "      <td></td>\n",
       "      <td>init=-1&amp;headckid=49f609c13719e8a0&amp;flushckid=1&amp;...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  scheme netloc       path params  \\\n",
       "0                /zhaopin/          \n",
       "\n",
       "                                               query fragment  \n",
       "0  init=-1&headckid=49f609c13719e8a0&flushckid=1&...           "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print(df.nunique())  # Pandas nunique() 用于获取唯一值的统计次数\n",
    "df.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "ckid             1\n",
      "compTag          6\n",
      "d_ckId           1\n",
      "d_curPage        1\n",
      "d_headId         1\n",
      "d_pageSize       1\n",
      "d_sfrom          1\n",
      "flushckid        1\n",
      "fromSearchBtn    1\n",
      "headckid         1\n",
      "init             1\n",
      "keyword          1\n",
      "siTag            1\n",
      "dtype: int64\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>keyword</th>\n",
       "      <th>compTag</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>design</td>\n",
       "      <td>155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>design</td>\n",
       "      <td>182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>design</td>\n",
       "      <td>186</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>design</td>\n",
       "      <td>189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>design</td>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>design</td>\n",
       "      <td>156</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  keyword compTag\n",
       "0  design     155\n",
       "1  design     182\n",
       "2  design     186\n",
       "3  design     189\n",
       "4  design     130\n",
       "5  design     156"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#df_qs = pd.DataFrame([ parse_qs(x) for x in df['query'] ])    query为使用布尔表达式查询帧的列\n",
    "df_qs = pd.DataFrame([{k:v[0] for k,v in parse_qs(x).items()} for x in df['query'] ])\n",
    "# for x in df['query']:\n",
    "#    for k,v in parse_qs(x).items():\n",
    "#         nd=dict()\n",
    "#         nd.update(k:v[0])\n",
    "print (df_qs.nunique())\n",
    "df_qs.head()\n",
    "df_qs[['keyword','compTag']]   #comTag 是不同的公司选择器, 数值不样, 对映到不同类型的公司  keyword 是搜查关键字"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'init': ['-1'], 'headckid': ['49f609c13719e8a0'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'keyword': ['design'], 'compTag': ['155'], 'ckid': ['49f609c13719e8a0'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['de352ed57e16600a3d85130dcb8090a4'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['de352ed57e16600a3d85130dcb8090a4']}\n"
     ]
    }
   ],
   "source": [
    "def parse_url_qs_for_compTag (url):\n",
    "    # 返回解析后url的参数\n",
    "    six_parts = urlparse(url) \n",
    "    out = parse_qs(six_parts.query)\n",
    "    return (out)\n",
    "mould = parse_url_qs_for_compTag(list(company_link.values())[0])      #拿第一个公司的url\n",
    "print(mould)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "155\n",
      "182\n",
      "186\n",
      "189\n",
      "130\n",
      "156\n"
     ]
    }
   ],
   "source": [
    "# [ parse_url_qs_for_compTag(x)['compTag'][0] for x in company_link.values()]\n",
    "for x in company_link.values():    \n",
    "    print(parse_url_qs_for_compTag(x)['compTag'][0] )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "中国500强 155\n",
      "2018互联网300强 182\n",
      "制造业500强 186\n",
      "AI创新成长50强  189\n",
      "独角兽 130\n",
      "上市公司 156\n"
     ]
    }
   ],
   "source": [
    "#dict_compTag = { k:parse_url_qs_for_compTag(v)['compTag'][0] for k,v in company_link.items()}\n",
    "#print (dict_compTag)\n",
    "for k,v in company_link.items():\n",
    "    print(k,parse_url_qs_for_compTag(v)['compTag'][0])   # 原本的：（冒号）要变为，（逗号）  大坑！！！"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'中国500强': {'init': ['-1'], 'headckid': ['49f609c13719e8a0'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'keyword': ['UI'], 'compTag': ['155'], 'ckid': ['49f609c13719e8a0'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['de352ed57e16600a3d85130dcb8090a4'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['de352ed57e16600a3d85130dcb8090a4']}, '2018互联网300强': {'init': ['-1'], 'headckid': ['49f609c13719e8a0'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'keyword': ['UI'], 'compTag': ['182'], 'ckid': ['49f609c13719e8a0'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['de352ed57e16600a3d85130dcb8090a4'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['de352ed57e16600a3d85130dcb8090a4']}, '制造业500强': {'init': ['-1'], 'headckid': ['49f609c13719e8a0'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'keyword': ['UI'], 'compTag': ['186'], 'ckid': ['49f609c13719e8a0'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['de352ed57e16600a3d85130dcb8090a4'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['de352ed57e16600a3d85130dcb8090a4']}, 'AI创新成长50强 ': {'init': ['-1'], 'headckid': ['49f609c13719e8a0'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'keyword': ['UI'], 'compTag': ['189'], 'ckid': ['49f609c13719e8a0'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['de352ed57e16600a3d85130dcb8090a4'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['de352ed57e16600a3d85130dcb8090a4']}, '独角兽': {'init': ['-1'], 'headckid': ['49f609c13719e8a0'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'keyword': ['UI'], 'compTag': ['130'], 'ckid': ['49f609c13719e8a0'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['de352ed57e16600a3d85130dcb8090a4'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['de352ed57e16600a3d85130dcb8090a4']}, '上市公司': {'init': ['-1'], 'headckid': ['49f609c13719e8a0'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'keyword': ['UI'], 'compTag': ['156'], 'ckid': ['49f609c13719e8a0'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['de352ed57e16600a3d85130dcb8090a4'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['de352ed57e16600a3d85130dcb8090a4']}}\n"
     ]
    }
   ],
   "source": [
    "def prams_mould(compTag , keyword ):\n",
    "    prams = mould.copy()   # mould是用parse_url_qs_for_compTag函数解析后的第一个公司赋予的变量\n",
    "    prams['compTag'] = compTag\n",
    "    prams['keyword'] = keyword\n",
    "    return (prams)\n",
    "\n",
    "prams_compTag_UI = { k:prams_mould(compTag = [v], keyword = ['UI']) for k,v in dict_compTag.items()}\n",
    "print(prams_compTag_UI)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'https://www.liepin.com/zhaopin/?init=-1&headckid=49f609c13719e8a0&flushckid=1&fromSearchBtn=2&keyword=UI&compTag=155&ckid=49f609c13719e8a0&siTag=1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=de352ed57e16600a3d85130dcb8090a4&d_curPage=0&d_pageSize=40&d_headId=de352ed57e16600a3d85130dcb8090a4'"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "url = \"https://www.liepin.com/zhaopin/\"\n",
    "session = HTMLSession()\n",
    "payload = prams_compTag_UI['中国500强']   #在搜索UI的关键字后，再点击中国500强后的url,在这里调用了上满的函数\n",
    "r = session.get( url, params = payload)\n",
    "r.url"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [],
   "source": [
    "session = HTMLSession()\n",
    "\n",
    "def requests_liepin( url, params):\n",
    "    r = session.get( url , params = payload)\n",
    "\n",
    "    # 先取特定元素, 精准打击其子后辈\n",
    "    主要元素 = r.html.xpath( '//ul[@class=\"sojob-list\"]/li')\n",
    "\n",
    "    # 作为xpath字典，键为我要抓的牛肉名称，值为xpath\n",
    "    dict_xpaths={ \n",
    "        'text': {\n",
    "            'edu':      '//div[contains(@class,\"job-info\")]/p/span[@class=\"edu\"]',\n",
    "            '经验':      '//div[contains(@class,\"job-info\")]/p/span[@class=\"edu\"]/following-sibling::span',\n",
    "            '薪水':    '//div[contains(@class,\"job-info\")]/p/span[@class=\"text-warning\"]', \n",
    "            '时间':    '//div[contains(@class,\"job-info\")]/p/time/@title', \n",
    "            '职称':    '//div[contains(@class,\"job-info\")]/h3/a', \n",
    "            '公司地点': '//div[contains(@class,\"job-info\")]/p/a',\n",
    "            '公司名称': '//div[contains(@class,\"sojob-item-main\")]//p[@class=\"company-name\"]/a', \n",
    "        },\n",
    "        'text_content': {\n",
    "        },\n",
    "        'href': {\n",
    "            '链结':    '//div[contains(@class,\"job-info\")]/h3/a', \n",
    "            '公司URL': '//div[contains(@class,\"sojob-item-main\")]//p[@class=\"company-name\"]/a', \n",
    "        }\n",
    "    }\n",
    "\n",
    "    def get_e_text_content(_xpath_):\n",
    "        # 高级列表推导\n",
    "        暂存结果 = [e.xpath(_xpath_)[0].lxml.text_content() for e in 主要元素]\n",
    "        return(暂存结果)\n",
    "\n",
    "    def get_e_text(_xpath_):\n",
    "        # 高级列表推导\n",
    "        暂存结果 = [\"\".join([x.strip() if type(x) is str else x.text.strip() for x in e.xpath(_xpath_)]) for e in 主要元素]\n",
    "        return(暂存结果)\n",
    "\n",
    "    def get_e_href(_xpath_):\n",
    "        # 高级列表推导\n",
    "        暂存结果 = [list(e.xpath(_xpath_, first=True).absolute_links)[0] \\\n",
    "                   if len(e.xpath(_xpath_, first=True).absolute_links) >= 1  \\\n",
    "                   else \"\" for e in 主要元素]\n",
    "        return(暂存结果)\n",
    "\n",
    "    # 只对主要元素下进行.\n",
    "    \n",
    "    数据字典 = dict()\n",
    "\n",
    "    数据字典 = {k:get_e_text_content(v) for k,v in dict_xpaths['text_content'].items()}\n",
    "    数据字典.update({k:get_e_text(v) for k,v in dict_xpaths['text'].items()})\n",
    "    数据字典.update({k:get_e_href(v) for k,v in dict_xpaths['href'].items()})\n",
    "\n",
    "    数据 = pd.DataFrame(数据字典)\n",
    "    #数据.to_excel(\"20春_Web数据挖掘_week03_liepin.xlsx\", sheet_name=\"搜查结果\")\n",
    "    return (数据)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>edu</th>\n",
       "      <th>经验</th>\n",
       "      <th>薪水</th>\n",
       "      <th>时间</th>\n",
       "      <th>职称</th>\n",
       "      <th>公司地点</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>链结</th>\n",
       "      <th>公司URL</th>\n",
       "      <th>热门公司类型</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>10年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>集团办公室副主任</td>\n",
       "      <td>苏州-吴江区</td>\n",
       "      <td>盛虹控股集团有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927078451.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7966465/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>10-20k·16薪</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>大客户销售经理-杭州-网易严选</td>\n",
       "      <td>杭州</td>\n",
       "      <td>网易集团</td>\n",
       "      <td>https://www.liepin.com/job/1926482689.shtml</td>\n",
       "      <td>https://www.liepin.com/company/5964833/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>家具/家居产品设计师-严选事业部</td>\n",
       "      <td>杭州-滨江区</td>\n",
       "      <td>网易集团</td>\n",
       "      <td>https://www.liepin.com/job/1926109575.shtml</td>\n",
       "      <td>https://www.liepin.com/company/5964833/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1年以上</td>\n",
       "      <td>8-12k·13薪</td>\n",
       "      <td>2020年04月05日</td>\n",
       "      <td>HRBP助理</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>网易集团</td>\n",
       "      <td>https://www.liepin.com/job/1927237301.shtml</td>\n",
       "      <td>https://www.liepin.com/company/5964833/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>2年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月03日</td>\n",
       "      <td>广告销售大客户经理</td>\n",
       "      <td></td>\n",
       "      <td>网易集团</td>\n",
       "      <td>https://www.liepin.com/job/1919211941.shtml</td>\n",
       "      <td>https://www.liepin.com/company/5964833/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>25-40k·16薪</td>\n",
       "      <td>2020年04月01日</td>\n",
       "      <td>市场营销专家</td>\n",
       "      <td>杭州-滨江区</td>\n",
       "      <td>网易集团</td>\n",
       "      <td>https://www.liepin.com/job/1927140759.shtml</td>\n",
       "      <td>https://www.liepin.com/company/5964833/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>15-30k·16薪</td>\n",
       "      <td>2020年03月31日</td>\n",
       "      <td>高级/资深测试开发工程师</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>网易集团</td>\n",
       "      <td>https://www.liepin.com/job/1927109999.shtml</td>\n",
       "      <td>https://www.liepin.com/company/5964833/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>20-30k·12薪</td>\n",
       "      <td>2020年03月25日</td>\n",
       "      <td>测试开发工程师</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>网易集团</td>\n",
       "      <td>https://www.liepin.com/job/1926951215.shtml</td>\n",
       "      <td>https://www.liepin.com/company/5964833/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>15-25k·12薪</td>\n",
       "      <td>2020年03月25日</td>\n",
       "      <td>游戏测试</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>网易集团</td>\n",
       "      <td>https://www.liepin.com/job/1926935149.shtml</td>\n",
       "      <td>https://www.liepin.com/company/5964833/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>7年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>天猫消费电子-高级整合营销专家-杭州</td>\n",
       "      <td>杭州</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927266211.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>6年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>天猫消费电子事业部-到家服务频道运营专家-服务生态发展部</td>\n",
       "      <td>杭州</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927266209.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>6年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>天猫消费电子-手机品牌经理-杭州</td>\n",
       "      <td>杭州</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927266207.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>智能服务事业部-客户端技术专家-杭州</td>\n",
       "      <td>杭州</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927266205.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>6年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>天猫消费电子-平台运营产品专家-杭州</td>\n",
       "      <td>杭州</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927266203.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>8年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>天猫消费电子-内容营销专家-杭州</td>\n",
       "      <td>杭州</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927266201.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>智能服务事业部-音视频服务端技术专家-杭州</td>\n",
       "      <td>杭州</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927266199.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>湖畔大学-CEO知行训练营 产品经理-杭州</td>\n",
       "      <td>杭州</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927266197.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>阿里汽车-汽车KOL经纪人-杭州</td>\n",
       "      <td>杭州</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927266195.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>15-25k·12薪</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>DBA主管</td>\n",
       "      <td>无锡-宜兴</td>\n",
       "      <td>远东控股集团</td>\n",
       "      <td>https://www.liepin.com/job/1927266115.shtml</td>\n",
       "      <td>https://www.liepin.com/company/2892805/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>集团战略部_资深顾问</td>\n",
       "      <td>北京</td>\n",
       "      <td>Baidu</td>\n",
       "      <td>https://www.liepin.com/job/1927265993.shtml</td>\n",
       "      <td>https://www.liepin.com/company/884492/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>合肥战区战区房修工程岗</td>\n",
       "      <td></td>\n",
       "      <td>江苏中南</td>\n",
       "      <td>https://www.liepin.com/job/1927265739.shtml</td>\n",
       "      <td>https://www.liepin.com/company/2331894/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>阿里汽车-私域流量运营专家-杭州</td>\n",
       "      <td>杭州</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927265683.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>阿里汽车-用户产品运营专家-杭州</td>\n",
       "      <td>杭州</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927265681.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>阿里汽车-产品运营专家（SF项目）-杭州</td>\n",
       "      <td>杭州</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927265679.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1年以上</td>\n",
       "      <td>8-12k·12薪</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>项目工程师（PM） (MJ000221)</td>\n",
       "      <td>青岛-崂山区</td>\n",
       "      <td>海尔智家</td>\n",
       "      <td>https://www.liepin.com/job/1927265283.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9671743/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>盒马-高级零售解决方案产品专家-商品</td>\n",
       "      <td>杭州</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927265265.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>猫超产品技术&amp;手猫技术部-技术专家-淘鲜达</td>\n",
       "      <td>杭州</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927265263.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>阿里集团-业务机制设计与运营-高级专家</td>\n",
       "      <td>杭州</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927265261.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>阿里集团-内容商业化产品高级专家</td>\n",
       "      <td>杭州</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927265259.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>15-25k·13薪</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>高级HRIS专员（效率产品方向）</td>\n",
       "      <td>杭州</td>\n",
       "      <td>网易集团</td>\n",
       "      <td>https://www.liepin.com/job/1927265167.shtml</td>\n",
       "      <td>https://www.liepin.com/company/5964833/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>10年以上</td>\n",
       "      <td>10-20k·12薪</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>设备管理工程师</td>\n",
       "      <td>宣城-广德县</td>\n",
       "      <td>安徽广信农化股份有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1915282870.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7979059/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>10-15k·15薪</td>\n",
       "      <td>2020年04月07日</td>\n",
       "      <td>物业项目经理-连云港海州吾悦</td>\n",
       "      <td>连云港</td>\n",
       "      <td>新城悦控股有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927237635.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9119624/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>20-30k·12薪</td>\n",
       "      <td>2020年04月06日</td>\n",
       "      <td>云计算销售经理</td>\n",
       "      <td>上海-虹桥</td>\n",
       "      <td>富通东方</td>\n",
       "      <td>https://www.liepin.com/job/1927239637.shtml</td>\n",
       "      <td>https://www.liepin.com/company/895509/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>8-10k·15薪</td>\n",
       "      <td>2020年04月06日</td>\n",
       "      <td>婴童产品设计师(005261)</td>\n",
       "      <td>广州-珠江新城</td>\n",
       "      <td>奥飞</td>\n",
       "      <td>https://www.liepin.com/job/1926824169.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7875551/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1年以上</td>\n",
       "      <td>10-15k·14薪</td>\n",
       "      <td>2020年04月06日</td>\n",
       "      <td>上位机软件开发工程师</td>\n",
       "      <td>无锡-蠡园</td>\n",
       "      <td>信捷电气</td>\n",
       "      <td>https://www.liepin.com/job/1912928019.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7977772/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1年以上</td>\n",
       "      <td>8-12k·13薪</td>\n",
       "      <td>2020年04月05日</td>\n",
       "      <td>HRBP助理</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>网易集团</td>\n",
       "      <td>https://www.liepin.com/job/1927237301.shtml</td>\n",
       "      <td>https://www.liepin.com/company/5964833/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月04日</td>\n",
       "      <td>药化合成科研员</td>\n",
       "      <td>北京</td>\n",
       "      <td>百济神州</td>\n",
       "      <td>https://www.liepin.com/job/1927051303.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9289489/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月03日</td>\n",
       "      <td>工程质量负责人</td>\n",
       "      <td>合肥-蜀山区</td>\n",
       "      <td>中环环保</td>\n",
       "      <td>https://www.liepin.com/job/1927206977.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9304657/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>1年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月03日</td>\n",
       "      <td>蔚来产品专家(NIO Product Expert)</td>\n",
       "      <td></td>\n",
       "      <td>NIO蔚来</td>\n",
       "      <td>https://www.liepin.com/job/1926821777.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8524725/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>8-15k·12薪</td>\n",
       "      <td>2020年04月03日</td>\n",
       "      <td>医药代表 （长沙）</td>\n",
       "      <td>长沙</td>\n",
       "      <td>贝达药业</td>\n",
       "      <td>https://www.liepin.com/job/1924956041.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8206410/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>2年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月03日</td>\n",
       "      <td>广告销售大客户经理</td>\n",
       "      <td></td>\n",
       "      <td>网易集团</td>\n",
       "      <td>https://www.liepin.com/job/1919211941.shtml</td>\n",
       "      <td>https://www.liepin.com/company/5964833/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>15-20k·13薪</td>\n",
       "      <td>2020年04月03日</td>\n",
       "      <td>法务主管/主任</td>\n",
       "      <td>深圳</td>\n",
       "      <td>中国南玻集团股份有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927220089.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9091167/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>1年以上</td>\n",
       "      <td>5-8k·12薪</td>\n",
       "      <td>2020年04月02日</td>\n",
       "      <td>项目团队建设专员</td>\n",
       "      <td>遵义</td>\n",
       "      <td>新城控股集团住宅开发事业部</td>\n",
       "      <td>https://www.liepin.com/job/1927189015.shtml</td>\n",
       "      <td>https://www.liepin.com/company/442197/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>9-14k·13薪</td>\n",
       "      <td>2020年04月02日</td>\n",
       "      <td>暖通运维工程师</td>\n",
       "      <td>宁德</td>\n",
       "      <td>宁德时代新能源科技股份有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927179199.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8768998/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>2-3k·12薪</td>\n",
       "      <td>2020年04月02日</td>\n",
       "      <td>财务负责人（基建）</td>\n",
       "      <td>福州-鼓楼区</td>\n",
       "      <td>富春股份</td>\n",
       "      <td>https://www.liepin.com/job/1927174761.shtml</td>\n",
       "      <td>https://www.liepin.com/company/2366812/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月02日</td>\n",
       "      <td>信审经理（苏州、天津、济南）</td>\n",
       "      <td>苏州</td>\n",
       "      <td>远东国际融资租赁有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927173837.shtml</td>\n",
       "      <td>https://www.liepin.com/company/2696596/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月02日</td>\n",
       "      <td>信审经理（苏州、天津、济南）</td>\n",
       "      <td>济南</td>\n",
       "      <td>远东国际融资租赁有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927173835.shtml</td>\n",
       "      <td>https://www.liepin.com/company/2696596/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月02日</td>\n",
       "      <td>信审经理（苏州、天津、济南）</td>\n",
       "      <td>天津</td>\n",
       "      <td>远东国际融资租赁有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927173833.shtml</td>\n",
       "      <td>https://www.liepin.com/company/2696596/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2年以上</td>\n",
       "      <td>8-10k·13薪</td>\n",
       "      <td>2020年04月02日</td>\n",
       "      <td>法务主管（涉外方向）(005286)</td>\n",
       "      <td>广州</td>\n",
       "      <td>奥飞</td>\n",
       "      <td>https://www.liepin.com/job/1927169453.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7875551/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>1年以上</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>2020年04月02日</td>\n",
       "      <td>大客户活动策划</td>\n",
       "      <td>北京</td>\n",
       "      <td>空中信使信息技术北京</td>\n",
       "      <td>https://www.liepin.com/job/1926795937.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7880101/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>4年以上</td>\n",
       "      <td>12-18k·12薪</td>\n",
       "      <td>2020年04月02日</td>\n",
       "      <td>教学管理主管</td>\n",
       "      <td>武汉-武昌区</td>\n",
       "      <td>新东方教育科技集团有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1926698165.shtml</td>\n",
       "      <td>https://www.liepin.com/company/2485876/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月02日</td>\n",
       "      <td>教学产品经理</td>\n",
       "      <td>武汉-武昌区</td>\n",
       "      <td>新东方教育科技集团有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1926694451.shtml</td>\n",
       "      <td>https://www.liepin.com/company/2485876/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>2年以上</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>2020年04月02日</td>\n",
       "      <td>数据库开发工程师</td>\n",
       "      <td>上海-张江</td>\n",
       "      <td>空中信使信息技术北京</td>\n",
       "      <td>https://www.liepin.com/job/1926600865.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7880101/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1年以上</td>\n",
       "      <td>6-13k·12薪</td>\n",
       "      <td>2020年04月02日</td>\n",
       "      <td>西班牙语驻外翻译</td>\n",
       "      <td></td>\n",
       "      <td>风范股份</td>\n",
       "      <td>https://www.liepin.com/job/1919764817.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9512840/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>2年以上</td>\n",
       "      <td>5-10k·12薪</td>\n",
       "      <td>2020年04月02日</td>\n",
       "      <td>财务主管</td>\n",
       "      <td>天津</td>\n",
       "      <td>大禹节水</td>\n",
       "      <td>https://www.liepin.com/job/1913355131.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9135243/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>6-10k·12薪</td>\n",
       "      <td>2020年04月01日</td>\n",
       "      <td>销售事务主管</td>\n",
       "      <td>遵义</td>\n",
       "      <td>新城控股集团住宅开发事业部</td>\n",
       "      <td>https://www.liepin.com/job/1927150427.shtml</td>\n",
       "      <td>https://www.liepin.com/company/442197/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>25-40k·16薪</td>\n",
       "      <td>2020年04月01日</td>\n",
       "      <td>市场营销专家</td>\n",
       "      <td>杭州-滨江区</td>\n",
       "      <td>网易集团</td>\n",
       "      <td>https://www.liepin.com/job/1927140759.shtml</td>\n",
       "      <td>https://www.liepin.com/company/5964833/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>8-15k·15薪</td>\n",
       "      <td>2020年04月01日</td>\n",
       "      <td>员工关系主管</td>\n",
       "      <td>深圳-平湖</td>\n",
       "      <td>深圳市豪鹏科技有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1924546859.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7938237/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>6年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月01日</td>\n",
       "      <td>培训与人才发展高级经理TD</td>\n",
       "      <td>武汉-武昌区</td>\n",
       "      <td>新东方教育科技集团有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1918666773.shtml</td>\n",
       "      <td>https://www.liepin.com/company/2485876/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>15-30k·16薪</td>\n",
       "      <td>2020年03月31日</td>\n",
       "      <td>高级/资深测试开发工程师</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>网易集团</td>\n",
       "      <td>https://www.liepin.com/job/1927109999.shtml</td>\n",
       "      <td>https://www.liepin.com/company/5964833/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>240 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      edu     经验          薪水           时间                            职称  \\\n",
       "0    统招本科  10年以上          面议  2020年04月07日                      集团办公室副主任   \n",
       "1   本科及以上   3年以上  10-20k·16薪  2020年04月07日               大客户销售经理-杭州-网易严选   \n",
       "2    统招本科   5年以上          面议  2020年04月07日              家具/家居产品设计师-严选事业部   \n",
       "3   本科及以上   1年以上   8-12k·13薪  2020年04月05日                        HRBP助理   \n",
       "4   大专及以上   2年以上          面议  2020年04月03日                     广告销售大客户经理   \n",
       "5    统招本科   3年以上  25-40k·16薪  2020年04月01日                        市场营销专家   \n",
       "6    统招本科   经验不限  15-30k·16薪  2020年03月31日                  高级/资深测试开发工程师   \n",
       "7   本科及以上   3年以上  20-30k·12薪  2020年03月25日                       测试开发工程师   \n",
       "8    统招本科   3年以上  15-25k·12薪  2020年03月25日                          游戏测试   \n",
       "9    学历不限   7年以上          面议  2020年04月07日            天猫消费电子-高级整合营销专家-杭州   \n",
       "10   学历不限   6年以上          面议  2020年04月07日  天猫消费电子事业部-到家服务频道运营专家-服务生态发展部   \n",
       "11   学历不限   6年以上          面议  2020年04月07日              天猫消费电子-手机品牌经理-杭州   \n",
       "12   学历不限   3年以上          面议  2020年04月07日            智能服务事业部-客户端技术专家-杭州   \n",
       "13   学历不限   6年以上          面议  2020年04月07日            天猫消费电子-平台运营产品专家-杭州   \n",
       "14   学历不限   8年以上          面议  2020年04月07日              天猫消费电子-内容营销专家-杭州   \n",
       "15   学历不限   3年以上          面议  2020年04月07日         智能服务事业部-音视频服务端技术专家-杭州   \n",
       "16   学历不限   5年以上          面议  2020年04月07日         湖畔大学-CEO知行训练营 产品经理-杭州   \n",
       "17   学历不限   5年以上          面议  2020年04月07日              阿里汽车-汽车KOL经纪人-杭州   \n",
       "18  本科及以上   5年以上  15-25k·12薪  2020年04月07日                         DBA主管   \n",
       "19   统招本科   5年以上          面议  2020年04月07日                    集团战略部_资深顾问   \n",
       "20  大专及以上   3年以上    6-8k·12薪  2020年04月07日                   合肥战区战区房修工程岗   \n",
       "21   学历不限   5年以上          面议  2020年04月07日              阿里汽车-私域流量运营专家-杭州   \n",
       "22   学历不限   5年以上          面议  2020年04月07日              阿里汽车-用户产品运营专家-杭州   \n",
       "23   学历不限   5年以上          面议  2020年04月07日          阿里汽车-产品运营专家（SF项目）-杭州   \n",
       "24  本科及以上   1年以上   8-12k·12薪  2020年04月07日          项目工程师（PM） (MJ000221)   \n",
       "25   学历不限   5年以上          面议  2020年04月07日            盒马-高级零售解决方案产品专家-商品   \n",
       "26   学历不限   3年以上          面议  2020年04月07日         猫超产品技术&手猫技术部-技术专家-淘鲜达   \n",
       "27   学历不限   5年以上          面议  2020年04月07日           阿里集团-业务机制设计与运营-高级专家   \n",
       "28   学历不限   5年以上          面议  2020年04月07日              阿里集团-内容商业化产品高级专家   \n",
       "29  本科及以上   3年以上  15-25k·13薪  2020年04月07日              高级HRIS专员（效率产品方向）   \n",
       "..    ...    ...         ...          ...                           ...   \n",
       "10   统招本科  10年以上  10-20k·12薪  2020年04月07日                       设备管理工程师   \n",
       "11  大专及以上   3年以上  10-15k·15薪  2020年04月07日                物业项目经理-连云港海州吾悦   \n",
       "12  本科及以上   5年以上  20-30k·12薪  2020年04月06日                       云计算销售经理   \n",
       "13  本科及以上   3年以上   8-10k·15薪  2020年04月06日               婴童产品设计师(005261)   \n",
       "14  本科及以上   1年以上  10-15k·14薪  2020年04月06日                    上位机软件开发工程师   \n",
       "15  本科及以上   1年以上   8-12k·13薪  2020年04月05日                        HRBP助理   \n",
       "16   学历不限   经验不限          面议  2020年04月04日                       药化合成科研员   \n",
       "17  大专及以上   5年以上          面议  2020年04月03日                       工程质量负责人   \n",
       "18   学历不限   1年以上          面议  2020年04月03日    蔚来产品专家(NIO Product Expert)   \n",
       "19  大专及以上   经验不限   8-15k·12薪  2020年04月03日                     医药代表 （长沙）   \n",
       "20  大专及以上   2年以上          面议  2020年04月03日                     广告销售大客户经理   \n",
       "21  本科及以上   5年以上  15-20k·13薪  2020年04月03日                       法务主管/主任   \n",
       "22  大专及以上   1年以上    5-8k·12薪  2020年04月02日                      项目团队建设专员   \n",
       "23  大专及以上   3年以上   9-14k·13薪  2020年04月02日                       暖通运维工程师   \n",
       "24  本科及以上   5年以上    2-3k·12薪  2020年04月02日                     财务负责人（基建）   \n",
       "25  本科及以上   2年以上          面议  2020年04月02日                信审经理（苏州、天津、济南）   \n",
       "26  本科及以上   2年以上          面议  2020年04月02日                信审经理（苏州、天津、济南）   \n",
       "27  本科及以上   2年以上          面议  2020年04月02日                信审经理（苏州、天津、济南）   \n",
       "28  本科及以上   2年以上   8-10k·13薪  2020年04月02日            法务主管（涉外方向）(005286)   \n",
       "29  大专及以上   1年以上    6-8k·12薪  2020年04月02日                       大客户活动策划   \n",
       "30   统招本科   4年以上  12-18k·12薪  2020年04月02日                        教学管理主管   \n",
       "31   统招本科   5年以上          面议  2020年04月02日                        教学产品经理   \n",
       "32   统招本科   2年以上  10-15k·12薪  2020年04月02日                      数据库开发工程师   \n",
       "33  本科及以上   1年以上   6-13k·12薪  2020年04月02日                      西班牙语驻外翻译   \n",
       "34   统招本科   2年以上   5-10k·12薪  2020年04月02日                          财务主管   \n",
       "35  大专及以上   3年以上   6-10k·12薪  2020年04月01日                        销售事务主管   \n",
       "36   统招本科   3年以上  25-40k·16薪  2020年04月01日                        市场营销专家   \n",
       "37  本科及以上   3年以上   8-15k·15薪  2020年04月01日                        员工关系主管   \n",
       "38  本科及以上   6年以上          面议  2020年04月01日                 培训与人才发展高级经理TD   \n",
       "39   统招本科   经验不限  15-30k·16薪  2020年03月31日                  高级/资深测试开发工程师   \n",
       "\n",
       "       公司地点             公司名称                                           链结  \\\n",
       "0    苏州-吴江区       盛虹控股集团有限公司  https://www.liepin.com/job/1927078451.shtml   \n",
       "1        杭州             网易集团  https://www.liepin.com/job/1926482689.shtml   \n",
       "2    杭州-滨江区             网易集团  https://www.liepin.com/job/1926109575.shtml   \n",
       "3    广州-天河区             网易集团  https://www.liepin.com/job/1927237301.shtml   \n",
       "4                       网易集团  https://www.liepin.com/job/1919211941.shtml   \n",
       "5    杭州-滨江区             网易集团  https://www.liepin.com/job/1927140759.shtml   \n",
       "6    广州-天河区             网易集团  https://www.liepin.com/job/1927109999.shtml   \n",
       "7    广州-天河区             网易集团  https://www.liepin.com/job/1926951215.shtml   \n",
       "8    广州-天河区             网易集团  https://www.liepin.com/job/1926935149.shtml   \n",
       "9        杭州             阿里巴巴  https://www.liepin.com/job/1927266211.shtml   \n",
       "10       杭州             阿里巴巴  https://www.liepin.com/job/1927266209.shtml   \n",
       "11       杭州             阿里巴巴  https://www.liepin.com/job/1927266207.shtml   \n",
       "12       杭州             阿里巴巴  https://www.liepin.com/job/1927266205.shtml   \n",
       "13       杭州             阿里巴巴  https://www.liepin.com/job/1927266203.shtml   \n",
       "14       杭州             阿里巴巴  https://www.liepin.com/job/1927266201.shtml   \n",
       "15       杭州             阿里巴巴  https://www.liepin.com/job/1927266199.shtml   \n",
       "16       杭州             阿里巴巴  https://www.liepin.com/job/1927266197.shtml   \n",
       "17       杭州             阿里巴巴  https://www.liepin.com/job/1927266195.shtml   \n",
       "18    无锡-宜兴           远东控股集团  https://www.liepin.com/job/1927266115.shtml   \n",
       "19       北京            Baidu  https://www.liepin.com/job/1927265993.shtml   \n",
       "20                      江苏中南  https://www.liepin.com/job/1927265739.shtml   \n",
       "21       杭州             阿里巴巴  https://www.liepin.com/job/1927265683.shtml   \n",
       "22       杭州             阿里巴巴  https://www.liepin.com/job/1927265681.shtml   \n",
       "23       杭州             阿里巴巴  https://www.liepin.com/job/1927265679.shtml   \n",
       "24   青岛-崂山区             海尔智家  https://www.liepin.com/job/1927265283.shtml   \n",
       "25       杭州             阿里巴巴  https://www.liepin.com/job/1927265265.shtml   \n",
       "26       杭州             阿里巴巴  https://www.liepin.com/job/1927265263.shtml   \n",
       "27       杭州             阿里巴巴  https://www.liepin.com/job/1927265261.shtml   \n",
       "28       杭州             阿里巴巴  https://www.liepin.com/job/1927265259.shtml   \n",
       "29       杭州             网易集团  https://www.liepin.com/job/1927265167.shtml   \n",
       "..      ...              ...                                          ...   \n",
       "10   宣城-广德县     安徽广信农化股份有限公司  https://www.liepin.com/job/1915282870.shtml   \n",
       "11      连云港        新城悦控股有限公司  https://www.liepin.com/job/1927237635.shtml   \n",
       "12    上海-虹桥             富通东方  https://www.liepin.com/job/1927239637.shtml   \n",
       "13  广州-珠江新城               奥飞  https://www.liepin.com/job/1926824169.shtml   \n",
       "14    无锡-蠡园             信捷电气  https://www.liepin.com/job/1912928019.shtml   \n",
       "15   广州-天河区             网易集团  https://www.liepin.com/job/1927237301.shtml   \n",
       "16       北京             百济神州  https://www.liepin.com/job/1927051303.shtml   \n",
       "17   合肥-蜀山区             中环环保  https://www.liepin.com/job/1927206977.shtml   \n",
       "18                     NIO蔚来  https://www.liepin.com/job/1926821777.shtml   \n",
       "19       长沙             贝达药业  https://www.liepin.com/job/1924956041.shtml   \n",
       "20                      网易集团  https://www.liepin.com/job/1919211941.shtml   \n",
       "21       深圳     中国南玻集团股份有限公司  https://www.liepin.com/job/1927220089.shtml   \n",
       "22       遵义    新城控股集团住宅开发事业部  https://www.liepin.com/job/1927189015.shtml   \n",
       "23       宁德  宁德时代新能源科技股份有限公司  https://www.liepin.com/job/1927179199.shtml   \n",
       "24   福州-鼓楼区             富春股份  https://www.liepin.com/job/1927174761.shtml   \n",
       "25       苏州     远东国际融资租赁有限公司  https://www.liepin.com/job/1927173837.shtml   \n",
       "26       济南     远东国际融资租赁有限公司  https://www.liepin.com/job/1927173835.shtml   \n",
       "27       天津     远东国际融资租赁有限公司  https://www.liepin.com/job/1927173833.shtml   \n",
       "28       广州               奥飞  https://www.liepin.com/job/1927169453.shtml   \n",
       "29       北京       空中信使信息技术北京  https://www.liepin.com/job/1926795937.shtml   \n",
       "30   武汉-武昌区    新东方教育科技集团有限公司  https://www.liepin.com/job/1926698165.shtml   \n",
       "31   武汉-武昌区    新东方教育科技集团有限公司  https://www.liepin.com/job/1926694451.shtml   \n",
       "32    上海-张江       空中信使信息技术北京  https://www.liepin.com/job/1926600865.shtml   \n",
       "33                      风范股份  https://www.liepin.com/job/1919764817.shtml   \n",
       "34       天津             大禹节水  https://www.liepin.com/job/1913355131.shtml   \n",
       "35       遵义    新城控股集团住宅开发事业部  https://www.liepin.com/job/1927150427.shtml   \n",
       "36   杭州-滨江区             网易集团  https://www.liepin.com/job/1927140759.shtml   \n",
       "37    深圳-平湖      深圳市豪鹏科技有限公司  https://www.liepin.com/job/1924546859.shtml   \n",
       "38   武汉-武昌区    新东方教育科技集团有限公司  https://www.liepin.com/job/1918666773.shtml   \n",
       "39   广州-天河区             网易集团  https://www.liepin.com/job/1927109999.shtml   \n",
       "\n",
       "                                      公司URL  热门公司类型  \n",
       "0   https://www.liepin.com/company/7966465/  中国500强  \n",
       "1   https://www.liepin.com/company/5964833/  中国500强  \n",
       "2   https://www.liepin.com/company/5964833/  中国500强  \n",
       "3   https://www.liepin.com/company/5964833/  中国500强  \n",
       "4   https://www.liepin.com/company/5964833/  中国500强  \n",
       "5   https://www.liepin.com/company/5964833/  中国500强  \n",
       "6   https://www.liepin.com/company/5964833/  中国500强  \n",
       "7   https://www.liepin.com/company/5964833/  中国500强  \n",
       "8   https://www.liepin.com/company/5964833/  中国500强  \n",
       "9   https://www.liepin.com/company/1072424/  中国500强  \n",
       "10  https://www.liepin.com/company/1072424/  中国500强  \n",
       "11  https://www.liepin.com/company/1072424/  中国500强  \n",
       "12  https://www.liepin.com/company/1072424/  中国500强  \n",
       "13  https://www.liepin.com/company/1072424/  中国500强  \n",
       "14  https://www.liepin.com/company/1072424/  中国500强  \n",
       "15  https://www.liepin.com/company/1072424/  中国500强  \n",
       "16  https://www.liepin.com/company/1072424/  中国500强  \n",
       "17  https://www.liepin.com/company/1072424/  中国500强  \n",
       "18  https://www.liepin.com/company/2892805/  中国500强  \n",
       "19   https://www.liepin.com/company/884492/  中国500强  \n",
       "20  https://www.liepin.com/company/2331894/  中国500强  \n",
       "21  https://www.liepin.com/company/1072424/  中国500强  \n",
       "22  https://www.liepin.com/company/1072424/  中国500强  \n",
       "23  https://www.liepin.com/company/1072424/  中国500强  \n",
       "24  https://www.liepin.com/company/9671743/  中国500强  \n",
       "25  https://www.liepin.com/company/1072424/  中国500强  \n",
       "26  https://www.liepin.com/company/1072424/  中国500强  \n",
       "27  https://www.liepin.com/company/1072424/  中国500强  \n",
       "28  https://www.liepin.com/company/1072424/  中国500强  \n",
       "29  https://www.liepin.com/company/5964833/  中国500强  \n",
       "..                                      ...     ...  \n",
       "10  https://www.liepin.com/company/7979059/    上市公司  \n",
       "11  https://www.liepin.com/company/9119624/    上市公司  \n",
       "12   https://www.liepin.com/company/895509/    上市公司  \n",
       "13  https://www.liepin.com/company/7875551/    上市公司  \n",
       "14  https://www.liepin.com/company/7977772/    上市公司  \n",
       "15  https://www.liepin.com/company/5964833/    上市公司  \n",
       "16  https://www.liepin.com/company/9289489/    上市公司  \n",
       "17  https://www.liepin.com/company/9304657/    上市公司  \n",
       "18  https://www.liepin.com/company/8524725/    上市公司  \n",
       "19  https://www.liepin.com/company/8206410/    上市公司  \n",
       "20  https://www.liepin.com/company/5964833/    上市公司  \n",
       "21  https://www.liepin.com/company/9091167/    上市公司  \n",
       "22   https://www.liepin.com/company/442197/    上市公司  \n",
       "23  https://www.liepin.com/company/8768998/    上市公司  \n",
       "24  https://www.liepin.com/company/2366812/    上市公司  \n",
       "25  https://www.liepin.com/company/2696596/    上市公司  \n",
       "26  https://www.liepin.com/company/2696596/    上市公司  \n",
       "27  https://www.liepin.com/company/2696596/    上市公司  \n",
       "28  https://www.liepin.com/company/7875551/    上市公司  \n",
       "29  https://www.liepin.com/company/7880101/    上市公司  \n",
       "30  https://www.liepin.com/company/2485876/    上市公司  \n",
       "31  https://www.liepin.com/company/2485876/    上市公司  \n",
       "32  https://www.liepin.com/company/7880101/    上市公司  \n",
       "33  https://www.liepin.com/company/9512840/    上市公司  \n",
       "34  https://www.liepin.com/company/9135243/    上市公司  \n",
       "35   https://www.liepin.com/company/442197/    上市公司  \n",
       "36  https://www.liepin.com/company/5964833/    上市公司  \n",
       "37  https://www.liepin.com/company/7938237/    上市公司  \n",
       "38  https://www.liepin.com/company/2485876/    上市公司  \n",
       "39  https://www.liepin.com/company/5964833/    上市公司  \n",
       "\n",
       "[240 rows x 10 columns]"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#将新列分配给DataFrame。返回一个新对象，其中除新列外还包含所有原始列。重新分配的现有列将被覆盖\n",
    "url = \"https://www.liepin.com/zhaopin/\"\n",
    "\n",
    "list_df = list()\n",
    "for k,v in prams_compTag_UI.items():\n",
    "    payload = v\n",
    "    df = requests_liepin( url, params = payload)\n",
    "    df = df.assign (热门公司类型 = k)    \n",
    "    list_df.append(df)\n",
    "\n",
    "df_all = pd.concat(list_df)\n",
    "df_all"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_all.to_excel(\"web_week03_liepin_各热门公司类型.xlsx\", sheet_name=\"搜查结果\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "edu         5\n",
      "经验         10\n",
      "薪水         75\n",
      "时间         23\n",
      "职称        190\n",
      "公司地点       77\n",
      "公司名称       81\n",
      "链结        200\n",
      "公司URL      81\n",
      "热门公司类型      6\n",
      "dtype: int64\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>职称</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>公司名称</th>\n",
       "      <th>edu</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>阿里巴巴</th>\n",
       "      <th>学历不限</th>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华为</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>网易集团</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华为</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>龙蟒佰利联集团股份有限公司</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>网易集团</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>小米</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>天能电池集团股份有限公司</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>科大讯飞</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>旷视科技</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>新东方教育科技集团有限公司</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>山东开创集团股份有限公司</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特斯联</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>依图</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华为</th>\n",
       "      <th>硕士及以上</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>明略科技集团</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>天能电池集团股份有限公司</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华峰集团</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>小米</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>欧菲光</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>宁德时代新能源科技股份有限公司</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>远东国际融资租赁有限公司</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>上海乂学教育科技有限公司</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>网易集团</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>群核信息技术</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NIO蔚来</th>\n",
       "      <th>学历不限</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特斯联</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>纷享销客</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>奥飞</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>诚邦生态环境股份有限公司</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>均胜集团</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>喜马拉雅</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>上海擎创信息技术有限公司</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京禧云企业管理有限公司</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>奥比中光</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京智米科技有限公司</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>信捷电气</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>信也科技</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>作业帮</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>人本集团</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>云智慧北京</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>奇瑞控股集团有限公司</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>安徽广信农化股份有限公司</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>江苏中南</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广日股份</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>欧菲光</th>\n",
       "      <th>硕士及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>明略科技集团</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>上海丹瑞生物医药科技有限公司</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>新城悦控股有限公司</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中联重科</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>招金矿业</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>岁宝百货</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>宝德投资深圳</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>山东荣信集团有限公司</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Baidu</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>小红书</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>上海擎创信息技术有限公司</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>富通东方</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>富春股份</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Baidu</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>104 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       职称\n",
       "公司名称            edu      \n",
       "阿里巴巴            学历不限   28\n",
       "华为              本科及以上   8\n",
       "网易集团            本科及以上   8\n",
       "华为              统招本科    8\n",
       "龙蟒佰利联集团股份有限公司   统招本科    7\n",
       "网易集团            统招本科    7\n",
       "小米              本科及以上   6\n",
       "天能电池集团股份有限公司    本科及以上   6\n",
       "科大讯飞            本科及以上   5\n",
       "旷视科技            本科及以上   5\n",
       "新东方教育科技集团有限公司   统招本科    5\n",
       "山东开创集团股份有限公司    大专及以上   5\n",
       "特斯联             统招本科    4\n",
       "依图              本科及以上   4\n",
       "华为              硕士及以上   4\n",
       "明略科技集团          统招本科    4\n",
       "天能电池集团股份有限公司    大专及以上   3\n",
       "华峰集团            本科及以上   3\n",
       "小米              统招本科    3\n",
       "欧菲光             本科及以上   3\n",
       "宁德时代新能源科技股份有限公司 大专及以上   3\n",
       "远东国际融资租赁有限公司    本科及以上   3\n",
       "上海乂学教育科技有限公司    统招本科    2\n",
       "网易集团            大专及以上   2\n",
       "群核信息技术          本科及以上   2\n",
       "NIO蔚来           学历不限    2\n",
       "特斯联             本科及以上   2\n",
       "纷享销客            统招本科    2\n",
       "奥飞              本科及以上   2\n",
       "诚邦生态环境股份有限公司    大专及以上   2\n",
       "...                    ..\n",
       "均胜集团            本科及以上   1\n",
       "喜马拉雅            本科及以上   1\n",
       "上海擎创信息技术有限公司    统招本科    1\n",
       "北京禧云企业管理有限公司    大专及以上   1\n",
       "奥比中光            本科及以上   1\n",
       "北京智米科技有限公司      本科及以上   1\n",
       "信捷电气            本科及以上   1\n",
       "信也科技            统招本科    1\n",
       "作业帮             统招本科    1\n",
       "人本集团            本科及以上   1\n",
       "云智慧北京           本科及以上   1\n",
       "奇瑞控股集团有限公司      大专及以上   1\n",
       "安徽广信农化股份有限公司    统招本科    1\n",
       "江苏中南            大专及以上   1\n",
       "广日股份            本科及以上   1\n",
       "欧菲光             硕士及以上   1\n",
       "明略科技集团          本科及以上   1\n",
       "上海丹瑞生物医药科技有限公司  本科及以上   1\n",
       "新城悦控股有限公司       大专及以上   1\n",
       "中联重科            统招本科    1\n",
       "招金矿业            统招本科    1\n",
       "岁宝百货            本科及以上   1\n",
       "宝德投资深圳          统招本科    1\n",
       "山东荣信集团有限公司      本科及以上   1\n",
       "Baidu           统招本科    1\n",
       "小红书             统招本科    1\n",
       "上海擎创信息技术有限公司    大专及以上   1\n",
       "富通东方            本科及以上   1\n",
       "富春股份            本科及以上   1\n",
       "Baidu           本科及以上   1\n",
       "\n",
       "[104 rows x 1 columns]"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print (df_all.nunique())\n",
    "df_all[['edu']].drop_duplicates()\n",
    "\n",
    "df_all.groupby(['公司名称','edu']).agg({\"职称\":\"count\"}).sort_values(by='职称', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
